[ROOT]  dt  DimGeography  <  WHERE DimSalesTerritoryId EQ '9'  >   

40 items

DimGeographyIdCityCountryCodeDimSalesTerritoryIdEnglishCountryNameFrenchCountryNameIpAddressLocatorPostalCodeSpanishCountryNameStateOrProvinceCodeStateOrProvinceName
1AlexandriaAU9AustraliaAustralie198.51.100.22015AustraliaNSWNew South Wales
2Coffs HarbourAU9AustraliaAustralie198.51.100.32450AustraliaNSWNew South Wales
3DarlinghurstAU9AustraliaAustralie198.51.100.42010AustraliaNSWNew South Wales
4GoulburnAU9AustraliaAustralie198.51.100.52580AustraliaNSWNew South Wales
5Lane CoveAU9AustraliaAustralie198.51.100.61597AustraliaNSWNew South Wales
6Lavender BayAU9AustraliaAustralie198.51.100.72060AustraliaNSWNew South Wales
7MalabarAU9AustraliaAustralie198.51.100.82036AustraliaNSWNew South Wales
8MatravilleAU9AustraliaAustralie198.51.100.92036AustraliaNSWNew South Wales
9Milsons PointAU9AustraliaAustralie198.51.100.102061AustraliaNSWNew South Wales
10NewcastleAU9AustraliaAustralie198.51.100.112300AustraliaNSWNew South Wales
11North RydeAU9AustraliaAustralie198.51.100.122113AustraliaNSWNew South Wales
12North SydneyAU9AustraliaAustralie198.51.100.132055AustraliaNSWNew South Wales
13Port MacquarieAU9AustraliaAustralie198.51.100.142444AustraliaNSWNew South Wales
14RhodesAU9AustraliaAustralie198.51.100.152138AustraliaNSWNew South Wales
15SilverwaterAU9AustraliaAustralie198.51.100.162264AustraliaNSWNew South Wales
16SpringwoodAU9AustraliaAustralie198.51.100.172777AustraliaNSWNew South Wales
17St. LeonardsAU9AustraliaAustralie198.51.100.182065AustraliaNSWNew South Wales
18SydneyAU9AustraliaAustralie198.51.100.191002AustraliaNSWNew South Wales
19WollongongAU9AustraliaAustralie198.51.100.202500AustraliaNSWNew South Wales
20BrisbaneAU9AustraliaAustralie198.51.100.214000AustraliaQLDQueensland
21CaloundraAU9AustraliaAustralie198.51.100.224551AustraliaQLDQueensland
22East BrisbaneAU9AustraliaAustralie198.51.100.234169AustraliaQLDQueensland
23Gold CoastAU9AustraliaAustralie198.51.100.244217AustraliaQLDQueensland
24HawthorneAU9AustraliaAustralie198.51.100.254171AustraliaQLDQueensland
25Hervey BayAU9AustraliaAustralie198.51.100.264655AustraliaQLDQueensland
26RockhamptonAU9AustraliaAustralie198.51.100.274700AustraliaQLDQueensland
27TownsvilleAU9AustraliaAustralie198.51.100.284810AustraliaQLDQueensland
28CloverdaleAU9AustraliaAustralie198.51.100.296105AustraliaSASouth Australia
29FindonAU9AustraliaAustralie198.51.100.305023AustraliaSASouth Australia
30PerthAU9AustraliaAustralie198.51.100.316006AustraliaSASouth Australia
31HobartAU9AustraliaAustralie198.51.100.327001AustraliaTASTasmania
32BendigoAU9AustraliaAustralie198.51.100.333550AustraliaVICVictoria
33CranbourneAU9AustraliaAustralie198.51.100.343977AustraliaVICVictoria
34GeelongAU9AustraliaAustralie198.51.100.353220AustraliaVICVictoria
35MelbourneAU9AustraliaAustralie198.51.100.363000AustraliaVICVictoria
36MeltonAU9AustraliaAustralie198.51.100.373337AustraliaVICVictoria
37SeafordAU9AustraliaAustralie198.51.100.383198AustraliaVICVictoria
38South MelbourneAU9AustraliaAustralie198.51.100.393205AustraliaVICVictoria
39SunburyAU9AustraliaAustralie198.51.100.403429AustraliaVICVictoria
40WarrnamboolAU9AustraliaAustralie198.51.100.413280AustraliaVICVictoria

Generated 2024-05-03 14:45:12.546 UTC